Overview: .NET Expression

Add a field to the existing dataset by writing an expression in either C# (C Sharp) or VB.NET (Visual Basic .NET) languages. The values in the new field will be determined by the programmed expression, can either be a valid value or a null entry, and can be of any data type.

NOTE: CSense provides secure native blocks and operations for building analytics and solutions. The native capabilities provided by CSense can be extended by making use of this feature. When making use of this feature, please ensure that you have validated your extended functions to ensure that they perform as intended and do not introduce stability or security risks to your production system. Do not use scripts or components from untrusted sources.

Script execution

The script line is run every time the data recipe operation executes.

Note that if your script enters an infinite loop, the software may become unresponsive.

Limitations

Read more on limitations of the .NET script.

Properties

Category:	Add
Performance risk:	High potential performance risk. The performance is influenced by the size of the text file being imported, which is determined by number of rows and/or the number of columns of the dataset.
Knowledge required:	Working knowledge of a .NET language required

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	No
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	No
Does it modify the current dataset in any way?	Yes

Requirements

A dataset that contains at least one field of any data type.

Results

The dataset will be modified to contain the newly added field.